spring jpa 列名映射问题Unknown column 'redisrole0 |
您所在的位置：网站首页 › jpa save list › spring jpa 列名映射问题Unknown column 'redisrole0 |
|
在使用spring jpa 访问数据库表时，在实体类上定义的@column 会无效， package com.lujia.domain; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; import java.io.Serializable; import java.util.Date; /** * @author :lujia * @date :2018/11/16 10:22 */ @Entity @Table(name = "redis_role") public class RedisRole implements Serializable{ private static final long serialVersionUID = -3722607639305675814L; @Id private Long id; /** * @Column 注解无效 */ @Column(name = "mgmtName") private String mgmtName; private String remark; @Column(name = "createDate") private Date createDate; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getRemark() { return remark; } public void setRemark(String remark) { this.remark = remark; } public String getMgmtName() { return mgmtName; } public void setMgmtName(String mgmtName) { this.mgmtName = mgmtName; } public Date getCreateDate() { return createDate; } public void setCreateDate(Date createDate) { this.createDate = createDate; } }，直接访问数据库会报异常Unknown column 'redisrole0_.create_date' in 'field list' ，默认帮我们把列名给整成create_date这 种，所以回报异常，此时我们可以指定他的naming strategry , PhysicalNamingStrategyStandardImpl 类里面，会直接使用字段名和列名映射，就行了网上有些资料说的是指定这个属性，jpa:hibernate：naming：strategy: org.hibernate.cfg.ImprovedNamingStrategy 然后扩展ImprovedNamingStrategy 类，但是我试了，好像是不行的，不知道是不是我的方法不正确 spring: jpa: database: MySQL show-sql: true hibernate: naming: physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl /* * Hibernate, Relational Persistence for Idiomatic Java * * License: GNU Lesser General Public License (LGPL), version 2.1 or later. * See the lgpl.txt file in the root directory or . */ package org.hibernate.boot.model.naming; import java.io.Serializable; import org.hibernate.engine.jdbc.env.spi.JdbcEnvironment; /** * Standard implementation of the PhysicalNamingStrategy contract. * * @author Steve Ebersole */ public class PhysicalNamingStrategyStandardImpl implements PhysicalNamingStrategy, Serializable { /** * Singleton access */ public static final PhysicalNamingStrategyStandardImpl INSTANCE = new PhysicalNamingStrategyStandardImpl(); @Override public Identifier toPhysicalCatalogName(Identifier name, JdbcEnvironment context) { return name; } @Override public Identifier toPhysicalSchemaName(Identifier name, JdbcEnvironment context) { return name; } @Override public Identifier toPhysicalTableName(Identifier name, JdbcEnvironment context) { return name; } @Override public Identifier toPhysicalSequenceName(Identifier name, JdbcEnvironment context) { return name; } @Override public Identifier toPhysicalColumnName(Identifier name, JdbcEnvironment context) { return name; } }
|
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
| CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |